SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Perched atop a hill with south-facing views of Lake Mascoma, this thoughtfully designed home blends modern elegance with natural beauty. Nestled on 3.1 acres, a beautifully winding driveway welcomes you to this 2,592-square-foot retreat. The open lawn and rolling landscape offer an ideal space for gardening and outdoor activities, with a separate shed equipped with electricity—perfect for a tractor, gardening tools, or kayaks to enjoy on the lake. Inside, the open-concept first floor is flooded with natural light, featuring a kitchen with granite countertops, stainless steel appliances, and a live-edge wood bar—ideal for entertaining. A half bath and laundry room add convenience. The second floor offers a private primary suite with a walk-in closet, luxurious bath with a garden tub and separate shower, and private balcony overlooking scenic surroundings. A second spacious bedroom is found across the hall. The third floor boasts two expansive rooms, perfect for additional bedrooms, a home office, or a creative retreat. Large closets, windows, and skylights ensure these spaces are bright and welcoming. With recent renovations, this home is move in ready! Ideally located just minutes away from downtown Enfield, with its charming restaurants, public beach, and boat launch. Lebanon is a 10 min. drive for shopping, dining, and entertainment, while Dartmouth is under 20 min. Quick access to I-89. Don’t miss the chance to own this incredible home in the Upper Valley!
Description:This delightful residence is nestled in the picturesque village of Plainfield, NH. A truly inviting property that offers a harmonious blend of classic charm and modern comfort. As you approach the home, you'll be greeted by its timeless design and beautifully maintained lawn and gardens. The open-concept kitchen to dining to living room is perfect for both daily living and entertaining others. The well-appointed kitchen is a chef's dream, complete with newer fridge, a dishwasher, and microwave, generous granite counter space, and plenty of cabinetry for storage. Many other features including: Central AC, mudroom, second floor laundry, updated fixtures, newly painted throughout, and professional interior designer crafted rooms. Located just a short drive from local amenities and scenic attractions, this home combines the best of both worlds—peaceful village living with convenient access to everyday necessities. Only 15 miles (25mins) to DHMC! Don’t miss your chance to own this exceptional property. Agent related to sellers.
Description:So, you're probably wondering about the whole "location, location, location" thing in real estate, right? Well, this place totally nails it! Just a hop, skip, and a 15-minute drive away from Dartmouth University and Dartmouth Hitchcock Hospital, this sweet home is calling out for someone to make it their own. It's like it's sitting there waiting for you to throw some elbow grease and love into it, and boom, you've got yourself a real gem. Now, imagine a house with an open layout that's begging for a little bit of your creative flair. Picture big ol' bedrooms that could fit a king-sized bed with room to spare, and windows that offer views that'll make you want to sit back with a cup of joe and just take it all in. Oh, and let's not forget about that monster of a barn! It's like the ultimate man cave/she shed/playhouse for the kids/party spot all rolled into one. Plus, it comes with some extra outbuildings, so you'll have enough space to store all your toys, tools, or whatever else you can think of. You're looking at over 6 acres of pure fun. You can roam around outside, build some forts, throw a frisbee, or just kick back and enjoy the fresh air. If you're feeling adventurous, you can strap on your hiking boots or fire up the ATV/snowmobile and hit the trails, which are just a 2-minute stroll from your doorstep.
Description:Motivated Seller! Offers Deadline Sunday 6pm. This well maintained Cape home is nestled on a beautiful lot in a highly sought-after neighborhood in the heart of West Lebanon. As you step inside, you're greeted by a warm and inviting atmosphere that extends throughout every room. The first floor features an open-concept kitchen and dining area, seamlessly flowing into a bright and airy family/living room, along with a convenient half-bath. Upstairs, you'll find four bedrooms and a full bath, providing ample space for family, guests, or a home office. Beautifully maintained hardwood floors enhance the home's charm and character. On warm summer days, relax in the enclosed porch or step outside to enjoy the beautifully landscaped backyard. The spacious mudroom, located off the back entrance, leads to both the two-car garage and the backyard oasis. Whether you have a green thumb, enjoy outdoor activities, or simply want to unwind on the patio while listening to the gentle sounds of the man-made fountain, this space offers endless possibilities. The large basement provides plenty of storage and potential for future expansion—transform it into a home gym, private workshop, or additional finished living space. Situated in a prime location, this home is close to the Little League Field, shopping centers, and offers quick access to Hanover and surrounding amenities. A rare find, this move-in-ready home is perfect for full-time living.
Description:Step into history at The Treetops, an extraordinary 4-bedroom, 2-bath home that was once part of the original Saint-Gaudens estate. This stunning property carries the spirit of the famed Cornish Art Colony, where master sculptor Augustus Saint-Gaudens and his creative circle found inspiration in the rolling hills of New Hampshire. Perched on a scenic private lot, this home offers a tranquil retreat surrounded by nature. A gentle stream winds through the property, adding to the peaceful ambiance, while garden spaces provide the perfect setting for cultivating beauty—just as artists once did in this very landscape. From the sun-drenched rooms to the charming historic details, The Treetops is a timeless escape that seamlessly blends past and present. Located just minutes from the Upper Valley, with easy access to both sides of the Connecticut River, this home offers the perfect balance of seclusion and convenience—close to Dartmouth College, world-class healthcare, vibrant arts, and year-round outdoor recreation. This is more than just a home; it's a living piece of history in one of New Hampshire’s most picturesque and storied communities. Opportunities like this are rare—don’t miss your chance to own a legacy!
Description:"The Rock Ridge Community" offering 326 pristine acres of nature, trails, and riverfront access to all that the Upper Valley has to offer. The Upper Valley's Premier Neighborhood, all New Construction. This brand new home offers 3 bedroom, 2.5 bath home. Open concept living with hardwood floors, granite countertops, tiled baths and flexible floor plan. Share the community garden, enjoy socials at the Farmhouse, and the privileges that an HOA provides. Close to I89, DHMC, Dartmouth College, Lebanon 6 Movie Theater, Downtown and plenty of shopping. House is currently under construction with an estimated completion date of April 30th. All showings must be after 4pm weekdays or weekend, this is an active construction area please no unsupervised visits. Pictures in MLS are a facsimile of house being built.
Description:This 3 bedroom, 2 bath home may need some cosmetic updates but you will fall in love with the natural light and open floor plan! Light streams into the sunroom making it a cozy place to read a book or relax with your morning coffee. The living room features a big bay window to take in the Moose Mountain ridge line through the trees and has a a wonderful propane gas fireplace for those chilly nights. The kitchen/dining area is spacious with access to a deck and you will love the walk in pantry off the laundry room. The primary bedroom has an en suite bath and there is a second bedroom and full bath as well. Downstairs you have your third bedroom or office, a nice big storage room and a mudroom attached to the 2 car garage. Don't miss the big outbuilding which is perfect for all your toys and a workshop! The land is beautiful with it's own apple orchard (110 tress!) and a big garden plot. A wonderful spot walking distance to the Hanover Center Green in Etna where we have a summer fair and walking trails nearby. A wonderful community just 15 minutes to DHMC and Dartmouth College! Delayed showings start on Saturday, March 29 from 2-4.
Description:Nestled along the shores of Mascoma Lake and surrounded by the historic Shaker Museum you’ll find the community of North Village. A unique cluster of lovely homes, stylized with a hint of day’s gone by yet very modern on the interior. That’s exactly what you’ll find at 51 Chosen Vale Lane, built in 2002 and lovingly cared for this home has many features not found in the others. The large primary suite consists of vaulted ceilings, a separate dressing/sitting room with fireplace and spacious bath. The additional second floor suite again boasts a private bath, and a loft for those adventurous ones in the family. The main level is perfect for entertaining with an open concept living room, kitchen and dining room with built-ins and hardwood floors throughout. Red Birch & Mahogany cabinets, granite countertops and plenty of room for the best of cooks. The living room center piece is a fireplace mantel hand crafted by Dana Robes. A first-floor bedroom with a full bath rounds off the main level. A fully covered 3 season porch allows for lovely views of the lake, all within a short walk to the private Association beach. The lower level has a wonderful family room complete with bar, workshop, storage and laundry. The systems include two Air conditioning units one for each floor, a Buderus heating system, and a whole house sprinkler system. The Association maintains the roads, landscaping and beaches. Easy commute to Dartmouth College and the Dartmouth Medical Center.
Description:Lovely, Well-Maintained Three Bedroom Sitting in the Beautiful Connecticut River Valley Overlooking the Majestic Views of Mount Ascutney. This home sits on splendidly landscaped property encompassing 13+ acres of beautiful farmland with 1400 feet of private, accessible frontage on the Connecticut River. A wonderful spot to picnic, swim, canoe, kayak, fish, or just relax while taking in nature. A spacious open-concept kitchen, dining, and living room setting make it the perfect spot to entertain. The living room opens up to a large deck with stairs, adding more area for enjoyment. The conveniently designed kitchen features an island, numerous cherry cabinets, granite counters, and two pantries. Two bedrooms are on the first floor, one has a private 3/4 bath, the second shares a full bath. One of the many highlights of this home is magnificent Primary Suite privately situated on the upper level, offering a gas fireplace, 3/4 bath, and expansive Great Room complete with gas fireplace, wet bar, and half bath. Your own private oasis. The partially finished basement w/family area w/walk-out to the backyard. The garage is large enough to accommodate 4 vehicles with direct entry into a large, tiled mudroom. The glorious landscaping boasts gardens of mature flowering plants, blueberry bushes, asparagus, vegetable garden space, and a 20 x 20 pole barn. There is an easy commute to the Upper Valley. Situated in the coveted Town of Cornish, with a rich history of the Cornish Colony.
Description:Located just outside the heart of Hanover, the home is perfect for those looking for privacy. The home features a functional layout designed to take advantage of its natural surroundings. Hardwood floors run throughout the main level, where a spacious living room with a pellet stove offers a cozy retreat during colder months. The main level is bright and sunny with a wrap-around deck off the main living space which provides an ideal spot for enjoying the warmer months. The lower level provides great overflow space and includes a gas fireplace, a laundry area, and a three quarter bath. A converted garage spaces now serves as a practical mudroom, storage area, or potential workshop. Outside, the property’s expansive front and back yards, offer ample space for outdoor activities, gardening, privacy, and relaxation. With its desirable location near hiking trails, schools, and cultural attractions, this home offers a quiet retreat without sacrificing proximity to Hanover’s vibrant downtown.